[ DB ] CONNECT:[ UseTime:0.000401s ] mysql:host=127.0.0.1;port=3306;dbname=bb2_yunhui_online2;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.000880s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `is_show` = 1 ORDER BY sort_order desc [ RunTime:0.007371s ]
[ SQL ] SHOW COLUMNS FROM `tp_seller` [ RunTime:0.001474s ]
[ SQL ] SELECT * FROM `tp_seller` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000602s ]
[ SQL ] SHOW COLUMNS FROM `tp_business_manager` [ RunTime:0.000558s ]
[ SQL ] SELECT * FROM `tp_business_manager` WHERE `manager_id` IS NULL LIMIT 1 [ RunTime:0.000365s ]
[ SQL ] SHOW COLUMNS FROM `tp_currency` [ RunTime:0.000469s ]
[ SQL ] SELECT * FROM `tp_currency` WHERE `lang_code` = 'zh' LIMIT 1 [ RunTime:0.000318s ]
[ SQL ] SELECT * FROM `tp_currency` WHERE `is_show` = 1 [ RunTime:0.000276s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `id` = 652 LIMIT 1 [ RunTime:0.000935s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.001480s ]
[ SQL ] SELECT `goods_id`,`cat_id3`,`goods_name_zh`,`goods_content_zh` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_state` = 1 AND `cat_id1` = 652 [ RunTime:0.015940s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `id` IN (12348,841,842,31389,39457,35808,869,840,21651,22236,10971,31012,831,36671,835,12347,5012,30915,12349,1203,12344,12342,834,12355,30703,30916,847,845,38678,12358) [ RunTime:0.001004s ]
[ SQL ] SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `store_count` > 0 [ RunTime:0.010557s ]
[ SQL ] SELECT `shop_price` FROM `tp_goods` WHERE ( is_on_sale = 1 and goods_id in (84,176,277,282,518,1586,2026,2344,2865,2932,2934,3037,3127,3150,3172,3242,3248,3321,3387,3437,3837,3903,3995,4172,4173,4186,4224,4235,4239,4286,4288,4298,4319,4320,4333,4342,4345,4350,4385,4398,4400,4434,4437,4439,4455,4514,4522,4525,4527,4530,4544,4546,4553,4560,4596,4597,4618,4622,4628,4635,4638,4644,4678,4708,4729,4736,4753,4758,4769,4786,4788,4807,4808,4812,4818,4830,4855,4857,4861,4871,4875,4897,4902,4907,4920,4937,4945,4986,5009,5034,5047,5050,5058,5092,5099,5108,5126,5128,5139,5154,5160,5161,5166,5169,5172,5191,5197,5219,5225,5226,5236,5240,5243,5249,5263,5265,5269,5271,5278,5297,5323,5331,5335,5340,5344,5346,5351,5366,5385,5390,5396,5398,5407,5416,5433,5450,5457,5467,5471,5475,5494,5498,5500,5501,5504,5514,5524,5529,5537,5539,5552,5557,5561,5571,5585,5591,5594,5595,5596,5599,5611,5629,5633,5643,5648,5657,5662,5665,5666,5667,5669,5688,5694,5699,5701,5702,5706,5714,5732,5741,5763,5790,5791,5807,5812,5816,5826,5852,5853,5884,5892,5899,5931,5934,5939,5966,5997,6007,6012,6013,6018,6033,6034,6041,6050,6063,6099,6104,6105,6108,6109,6113,6131,6133,6136,6159,6178,6180,6191,6193,6201,6243,6258,6266,6307,6345,6354,6357,6358,6383,6402,6450,6510,6539,6544,6555,6560,6564,6567,6571,6611,6624,6633,6641,6660,6693,6712,6721,6727,6766,6776,6778,6810,7639,7689,7691,8019,8033,8076,8092,8104,8121,8122,8185,8189,8213,8239,8263,8332,8340,8345,8360,8376,8387,8401,8414,8433,8520,8642,8662,8749,8789,8835,8976,8983,8988,9025,9030,9034,9039,9040,9043,9047,9051,9055,9057,9060,9064,9069,9079,9081,9089,9093,9121,9125,9147,9166,9181,9204,9213,9220,9246,9252,9254,9262,9263,9267,9281,9305,9314,9359,9363,9400,9408,9412,9442,9456,9462,9476,9482,9484,9486,9500,9503,9511,9517,9535,9555,9559,9586,9599,9620,9621,9682,9684,9688,9696,9723,9753,9776,9790,9791,9795,9803,9818,9830,9831,9838,9849,9850,9860,9876,9883,9891,9895,9900,9912,9927,9940,9944,9955,9958,9967,9983,9991,9993,10003,10013,10017,10020,10032,10036,10039,10047,10048,10049,10051,10053,10054,10056,10061,10062,10066,10084,10095,10104,10126,10142,10149,10156,10171,10179,10198,10210,10249,10255,10285,10291,10331,10334,10345,10389,10393,10399,10412,10414,10440,10442,10464,10482,10485,10496,10503,10504,10510,10527,10544,10548,10558,10559,10564) ) [ RunTime:0.002491s ]
[ SQL ] SELECT `cat_id1` FROM `tp_goods` WHERE ( is_on_sale = 1 ) AND `goods_id` IN (84,176,277,282,518,1586,2026,2344,2865,2932,2934,3037,3127,3150,3172,3242,3248,3321,3387,3437,3837,3903,3995,4172,4173,4186,4224,4235,4239,4286,4288,4298,4319,4320,4333,4342,4345,4350,4385,4398,4400,4434,4437,4439,4455,4514,4522,4525,4527,4530,4544,4546,4553,4560,4596,4597,4618,4622,4628,4635,4638,4644,4678,4708,4729,4736,4753,4758,4769,4786,4788,4807,4808,4812,4818,4830,4855,4857,4861,4871,4875,4897,4902,4907,4920,4937,4945,4986,5009,5034,5047,5050,5058,5092,5099,5108,5126,5128,5139,5154,5160,5161,5166,5169,5172,5191,5197,5219,5225,5226,5236,5240,5243,5249,5263,5265,5269,5271,5278,5297,5323,5331,5335,5340,5344,5346,5351,5366,5385,5390,5396,5398,5407,5416,5433,5450,5457,5467,5471,5475,5494,5498,5500,5501,5504,5514,5524,5529,5537,5539,5552,5557,5561,5571,5585,5591,5594,5595,5596,5599,5611,5629,5633,5643,5648,5657,5662,5665,5666,5667,5669,5688,5694,5699,5701,5702,5706,5714,5732,5741,5763,5790,5791,5807,5812,5816,5826,5852,5853,5884,5892,5899,5931,5934,5939,5966,5997,6007,6012,6013,6018,6033,6034,6041,6050,6063,6099,6104,6105,6108,6109,6113,6131,6133,6136,6159,6178,6180,6191,6193,6201,6243,6258,6266,6307,6345,6354,6357,6358,6383,6402,6450,6510,6539,6544,6555,6560,6564,6567,6571,6611,6624,6633,6641,6660,6693,6712,6721,6727,6766,6776,6778,6810,7639,7689,7691,8019,8033,8076,8092,8104,8121,8122,8185,8189,8213,8239,8263,8332,8340,8345,8360,8376,8387,8401,8414,8433,8520,8642,8662,8749,8789,8835,8976,8983,8988,9025,9030,9034,9039,9040,9043,9047,9051,9055,9057,9060,9064,9069,9079,9081,9089,9093,9121,9125,9147,9166,9181,9204,9213,9220,9246,9252,9254,9262,9263,9267,9281,9305,9314,9359,9363,9400,9408,9412,9442,9456,9462,9476,9482,9484,9486,9500,9503,9511,9517,9535,9555,9559,9586,9599,9620,9621,9682,9684,9688,9696,9723,9753,9776,9790,9791,9795,9803,9818,9830,9831,9838,9849,9850,9860,9876,9883,9891,9895,9900,9912,9927,9940,9944,9955,9958,9967,9983,9991,9993,10003,10013,10017,10020,10032,10036,10039,10047,10048,10049,10051,10053,10054,10056,10061,10062,10066,10084,10095,10104,10126,10142,10149,10156,10171,10179,10198,10210,10249,10255,10285,10291,10331,10334,10345,10389,10393,10399,10412,10414,10440,10442,10464,10482,10485,10496,10503,10504,10510,10527,10544,10548,10558,10559,10564) [ RunTime:0.003699s ]
[ SQL ] SHOW COLUMNS FROM `tp_brand` [ RunTime:0.001181s ]
[ SQL ] SELECT * FROM `tp_brand` WHERE `cat_id1` IN (652) AND `status` = 0 ORDER BY sort asc [ RunTime:0.001546s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`shop_price`,`sales_sum`,`store_count`,`comment_count`,`goods_name_zh`,`goods_content_zh` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (84,176,277,282,518,1586,2026,2344,2865,2932,2934,3037,3127,3150,3172,3242,3248,3321,3387,3437,3837,3903,3995,4172,4173,4186,4224,4235,4239,4286,4288,4298,4319,4320,4333,4342,4345,4350,4385,4398,4400,4434,4437,4439,4455,4514,4522,4525,4527,4530,4544,4546,4553,4560,4596,4597,4618,4622,4628,4635,4638,4644,4678,4708,4729,4736,4753,4758,4769,4786,4788,4807,4808,4812,4818,4830,4855,4857,4861,4871,4875,4897,4902,4907,4920,4937,4945,4986,5009,5034,5047,5050,5058,5092,5099,5108,5126,5128,5139,5154,5160,5161,5166,5169,5172,5191,5197,5219,5225,5226,5236,5240,5243,5249,5263,5265,5269,5271,5278,5297,5323,5331,5335,5340,5344,5346,5351,5366,5385,5390,5396,5398,5407,5416,5433,5450,5457,5467,5471,5475,5494,5498,5500,5501,5504,5514,5524,5529,5537,5539,5552,5557,5561,5571,5585,5591,5594,5595,5596,5599,5611,5629,5633,5643,5648,5657,5662,5665,5666,5667,5669,5688,5694,5699,5701,5702,5706,5714,5732,5741,5763,5790,5791,5807,5812,5816,5826,5852,5853,5884,5892,5899,5931,5934,5939,5966,5997,6007,6012,6013,6018,6033,6034,6041,6050,6063,6099,6104,6105,6108,6109,6113,6131,6133,6136,6159,6178,6180,6191,6193,6201,6243,6258,6266,6307,6345,6354,6357,6358,6383,6402,6450,6510,6539,6544,6555,6560,6564,6567,6571,6611,6624,6633,6641,6660,6693,6712,6721,6727,6766,6776,6778,6810,7639,7689,7691,8019,8033,8076,8092,8104,8121,8122,8185,8189,8213,8239,8263,8332,8340,8345,8360,8376,8387,8401,8414,8433,8520,8642,8662,8749,8789,8835,8976,8983,8988,9025,9030,9034,9039,9040,9043,9047,9051,9055,9057,9060,9064,9069,9079,9081,9089,9093,9121,9125,9147,9166,9181,9204,9213,9220,9246,9252,9254,9262,9263,9267,9281,9305,9314,9359,9363,9400,9408,9412,9442,9456,9462,9476,9482,9484,9486,9500,9503,9511,9517,9535,9555,9559,9586,9599,9620,9621,9682,9684,9688,9696,9723,9753,9776,9790,9791,9795,9803,9818,9830,9831,9838,9849,9850,9860,9876,9883,9891,9895,9900,9912,9927,9940,9944,9955,9958,9967,9983,9991,9993,10003,10013,10017,10020,10032,10036,10039,10047,10048,10049,10051,10053,10054,10056,10061,10062,10066,10084,10095,10104,10126,10142,10149,10156,10171,10179,10198,10210,10249,10255,10285,10291,10331,10334,10345,10389,10393,10399,10412,10414,10440,10442,10464,10482,10485,10496,10503,10504,10510,10527,10544,10548,10558,10559,10564) ORDER BY `sort` desc LIMIT 0,40 [ RunTime:0.006247s ]
[ SQL ] SHOW COLUMNS FROM `tp_menu_goods_field` [ RunTime:0.001605s ]
[ SQL ] SELECT * FROM `tp_menu_goods_field` [ RunTime:0.000550s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 6144 limit 2 [ RunTime:0.000820s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 9987 limit 2 [ RunTime:0.000841s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 37893 limit 2 [ RunTime:0.001007s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 35338 limit 2 [ RunTime:0.001027s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 15901 limit 2 [ RunTime:0.000759s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 1316 limit 2 [ RunTime:0.000694s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 1319 limit 2 [ RunTime:0.000904s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 6728 limit 2 [ RunTime:0.001125s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 6994 limit 2 [ RunTime:0.000761s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 37462 limit 2 [ RunTime:0.001691s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 6233 limit 2 [ RunTime:0.000926s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 16750 limit 2 [ RunTime:0.001041s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 34675 limit 2 [ RunTime:0.000762s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 27508 limit 2 [ RunTime:0.000729s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 9847 limit 2 [ RunTime:0.000941s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 9855 limit 2 [ RunTime:0.001030s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 652 limit 2 [ RunTime:0.000972s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 670 limit 2 [ RunTime:0.001056s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 5025 limit 2 [ RunTime:0.000953s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 1713 limit 2 [ RunTime:0.000626s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 17329 limit 2 [ RunTime:0.001090s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 34767 limit 2 [ RunTime:0.000759s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 11729 limit 2 [ RunTime:0.001523s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 35025 limit 2 [ RunTime:0.000750s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 36320 limit 2 [ RunTime:0.000696s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 737 limit 2 [ RunTime:0.000818s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 9192 limit 2 [ RunTime:0.000851s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 14065 limit 2 [ RunTime:0.000798s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 1315 limit 2 [ RunTime:0.000725s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 1318 limit 2 [ RunTime:0.000852s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 6196 limit 2 [ RunTime:0.000634s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 43575 limit 2 [ RunTime:0.000725s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748952499 and end_time > 1748952499 and status = 1 and cat_id1 = 1620 limit 2 [ RunTime:0.000662s ]
[ SQL ] SHOW COLUMNS FROM `tp_config` [ RunTime:0.000545s ]
[ SQL ] SELECT `name`,`value` FROM `tp_config` WHERE `name` IN ('oss_key_id','oss_key_secret','oss_endpoint','oss_bucket') [ RunTime:0.000521s ]
[ SQL ] select * from `tp_friend_link` where is_show=1 [ RunTime:0.000524s ]
[ SQL ] select * from `tp_friend_link` where is_show=1 [ RunTime:0.000301s ]
[ SQL ] SELECT * FROM `tp_navigation` where is_show = 1 AND position = 2 ORDER BY `sort` DESC [ RunTime:0.000307s ]